<?php
namespace Home\Model;
use Think\Model;
class InfoModel extends Model
{
   
    public function getInfoField(){
        $field = "id,title,content,linkman,tel,edate, CASE type
           WHEN 'invitejob' THEN '招聘信息'
           WHEN 'foster' THEN '培训信息'
           WHEN 'house' THEN '房屋信息'
           WHEN 'seekbuy' THEN '求购信息'
           WHEN 'recruitbusiness' THEN '招商引资'
           WHEN 'apartment' THEN '公寓信息'
           WHEN 'seekjob' THEN '求职信息'
           WHEN 'teaching' THEN '家教信息'
           WHEN 'car' THEN '车辆信息'
           WHEN 'sale' THEN '出售信息'
           WHEN 'search' THEN '寻人/物启示'
        END as type,CASE checkstate
           WHEN '1' THEN '已审核'
           WHEN '0' THEN '未审核' 
        END as checkstate";
            
        return $field;
    }
}

?>


